Excel 2019 - Logical, Informational and Financial Functions, Text Functions and Data Tables
      This course is part of the MOS exam 77-727 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam. In this course you will learn about Logical and Informational Functions. You will also learn about Financial Functions, Data Tables and Text Functions.      
      Logical and Informational Functions      
      Upon successful completion you will be able to:

1. Use the IF Function;
2. Use the OR Function;
3. Use the AND Function;
4. Use Help for Error Messages;
5. Use Nested IF Functions;
6. Understand IS Functions;
7. Use the ISERROR Function.		      
      More Logical Functions      
      Upon successful completion you will be able to:

1. Use the SUMIF Function;
2. Use the COUNTIF Function;
3. Use the AVERAGEIF Function.		      
      Financial Functions and Data Tables      
      Upon successful completion you will be able to:

1. Understand Financial Arguments;
2. Use the FV Function;
3. Use the PMT Function;
4. Use the NPV Function;
5. Use the Pv Argument;
6. Use the RATE Function;
7. Use NPV Function;
8. Use the Guess Argument;
9. Use Data Tables.		      
      Text Functions      
      Upon successful completion you will be able to:

1. Understand Text Functions;
2. Use the CONCATENATE Function;
3. Use the LOWER Function;
4. Use the LEFT Function;
5. Add Function Arguments;
6. Use the PROPER Function;
7. Use the UPPER Function
8. Understand the TRIM Function.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Logical, Informational and Financial Functions, Text Functions and Data Tables :
Program Training Courses - Microsoft Excel 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters